Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	1167947
Missing cells	7284116
Missing cells (%)	26.0%
Duplicate rows	348
Duplicate rows (%)	< 0.1%
Total size in memory	206.1 MiB
Average record size in memory	185.0 B

Variable types

Categorical	8
Text	5
Numeric	6
DateTime	1
Boolean	1
URL	3

Dataset

Description	EDA of TMDB Movie Dataset. Dataset Source: Asaniczka, and themoviedb.org. (2025). Full TMDB Movies Dataset 2024 (1M Movies) [Data set]. Kaggle. https://doi.org/10.34740/KAGGLE/DSV/10601279
URL	https://github.com/ekaterinaleks/RAG
Copyright	(c) ekaterinaleks 2025

Variable descriptions

id	Unique identifier for each movie
title	Title of the movie
vote_average	Average vote or rating given by viewers
vote_count	Total count of votes received for the movie
status	The status of the movie (e.g., Released, Rumored, Post Production, etc.)
release_date	Date when the movie was released
revenue	Total revenue generated by the movie
runtime	Duration of the movie in minutes
adult	Indicates if the movie is suitable only for adult audiences
backdrop_path	URL of the backdrop image for the movie
budget	Budget allocated for the movie
homepage	Official homepage URL of the movie
imdb_id	IMDb ID of the movie
original_language	Original language in which the movie was produced
original_title	Original title of the movie
overview	Brief description or summary of the movie
popularity	Popularity score of the movie
poster_path	URL of the movie poster image
tagline	Catchphrase or memorable line associated with the movie
genres	List of genres the movie belongs to
production_companies	List of production companies involved in the movie
production_countries	List of countries involved in the movie production
spoken_languages	List of languages spoken in the movie
keywords	Keywords associated with the movie

Alerts

Dataset has 348 (< 0.1%) duplicate rows	Duplicates
`id` has a high cardinality: 1167129 distinct values	High cardinality
`imdb_id` has a high cardinality: 608703 distinct values	High cardinality
`original_language` has a high cardinality: 174 distinct values	High cardinality
`genres` has a high cardinality: 13507 distinct values	High cardinality
`production_companies` has a high cardinality: 209322 distinct values	High cardinality
`production_countries` has a high cardinality: 10166 distinct values	High cardinality
`spoken_languages` has a high cardinality: 7106 distinct values	High cardinality
`status` is highly imbalanced (92.1%)	Imbalance
`adult` is highly imbalanced (54.7%)	Imbalance
`original_language` is highly imbalanced (57.9%)	Imbalance
`genres` is highly imbalanced (55.2%)	Imbalance
`production_countries` is highly imbalanced (59.8%)	Imbalance
`spoken_languages` is highly imbalanced (63.1%)	Imbalance
`release_date` has 200396 (17.2%) missing values	Missing
`backdrop_path` has 860158 (73.6%) missing values	Missing
`homepage` has 1044970 (89.5%) missing values	Missing
`imdb_id` has 557882 (47.8%) missing values	Missing
`overview` has 241564 (20.7%) missing values	Missing
`poster_path` has 374563 (32.1%) missing values	Missing
`tagline` has 1004366 (86.0%) missing values	Missing
`genres` has 473732 (40.6%) missing values	Missing
`production_companies` has 643803 (55.1%) missing values	Missing
`production_countries` has 523518 (44.8%) missing values	Missing
`spoken_languages` has 503846 (43.1%) missing values	Missing
`keywords` has 855292 (73.2%) missing values	Missing
`vote_count` is highly skewed (γ1 = 41.5415313)	Skewed
`revenue` is highly skewed (γ1 = 72.23530235)	Skewed
`runtime` is highly skewed (γ1 = 34.44181118)	Skewed
`budget` is highly skewed (γ1 = 52.50859104)	Skewed
`popularity` is highly skewed (γ1 = 175.761174)	Skewed
`id` is uniformly distributed	Uniform
`imdb_id` is uniformly distributed	Uniform
`vote_average` has 816876 (69.9%) zeros	Zeros
`vote_count` has 816638 (69.9%) zeros	Zeros
`revenue` has 1146743 (98.2%) zeros	Zeros
`runtime` has 327120 (28.0%) zeros	Zeros
`budget` has 1106990 (94.8%) zeros	Zeros
`popularity` has 143909 (12.3%) zeros	Zeros

Reproduction

Analysis started	2025-02-02 16:25:20.184274
Analysis finished	2025-02-02 16:28:01.648205
Duration	2 minutes and 41.46 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

id
Categorical

High cardinality Uniform

Unique identifier for each movie

Distinct	1167129
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

1219302	4
1214995	4
1265968	4
1268961	4
1200891	4
Other values (1167124)	1167927

Length

Max length	7
Median length	6
Mean length	6.2711484
Min length	1

Unique

Unique	1166655 ?
Unique (%)	99.9%

Sample

1st row	27205
2nd row	157336
3rd row	155
4th row	19995
5th row	24428

Common Values

Value	Count	Frequency (%)
1219302	4	< 0.1%
1214995	4	< 0.1%
1265968	4	< 0.1%
1268961	4	< 0.1%
1200891	4	< 0.1%
1258162	4	< 0.1%
1210786	4	< 0.1%
1225689	4	< 0.1%
1262773	4	< 0.1%
1265043	4	< 0.1%
Other values (1167119)	1167907	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1219302	4	< 0.1%
1209122	4	< 0.1%
1222224	4	< 0.1%
1257695	4	< 0.1%
1216162	4	< 0.1%
1263252	4	< 0.1%
1219760	4	< 0.1%
1252754	4	< 0.1%
1213633	4	< 0.1%
1264514	4	< 0.1%
Other values (1167119)	1167907	> 99.9%

title
Text

Title of the movie

Distinct	1000702
Distinct (%)	85.7%
Missing	13
Missing (%)	< 0.1%
Memory size	8.9 MiB

Length

Max length	324
Median length	247
Mean length	19.899456
Min length	1

Unique

Unique	937588 ?
Unique (%)	80.3%

Sample

1st row	Inception
2nd row	Interstellar
3rd row	The Dark Knight
4th row	Avatar
5th row	The Avengers

Value	Count	Frequency (%)
	68493	2.4%
2	19686	0.7%
live	14525	0.5%
love	14392	0.5%
3	10032	0.4%
night	7995	0.3%
life	7994	0.3%
story	7993	0.3%
big	6609	0.2%
world	6583	0.2%
Other values (393450)	2638665	94.1%

vote_average
Real number (ℝ)

Zeros

Average vote or rating given by viewers

Distinct	5024
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.83587

Minimum	0
Maximum	10
Zeros	816876
Zeros (%)	69.9%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4.5
95-th percentile	8
Maximum	10
Range	10
Interquartile range (IQR)	4.5

Descriptive statistics

Standard deviation	3.0015556
Coefficient of variation (CV)	1.6349499
Kurtosis	0.021203743
Mean	1.83587
Median Absolute Deviation (MAD)	0
Skewness	1.2477299
Sum	2144198.9
Variance	9.0093357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	816876	69.9%
6	30673	2.6%
5	29910	2.6%
10	25415	2.2%
7	24356	2.1%
8	19994	1.7%
4	11805	1.0%
2	9644	0.8%
5.5	8737	0.7%
6.5	8636	0.7%
Other values (5014)	181901	15.6%

Value	Count	Frequency (%)
0	816876	69.9%
0.5	378	< 0.1%
0.75	1	< 0.1%
0.8	106	< 0.1%
0.875	1	< 0.1%
0.9	2	< 0.1%
1	6534	0.6%
1.1	5	< 0.1%
1.167	3	< 0.1%
1.179	1	< 0.1%

Value	Count	Frequency (%)
10	25415	2.2%
9.98	1	< 0.1%
9.9	9	< 0.1%
9.875	1	< 0.1%
9.872	1	< 0.1%
9.833	6	< 0.1%
9.8	121	< 0.1%
9.769	1	< 0.1%
9.763	1	< 0.1%
9.75	22	< 0.1%

vote_count
Real number (ℝ)

Skewed Zeros

Total count of votes received for the movie

Distinct	3598
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.36544

Minimum	0
Maximum	34495
Zeros	816638
Zeros (%)	69.9%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	15
Maximum	34495
Range	34495
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	314.22717
Coefficient of variation (CV)	17.1097
Kurtosis	2361.4737
Mean	18.36544
Median Absolute Deviation (MAD)	0
Skewness	41.541531
Sum	21449861
Variance	98738.716
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	816638	69.9%
1	126656	10.8%
2	49219	4.2%
3	28741	2.5%
4	20841	1.8%
5	14940	1.3%
6	11098	1.0%
7	8548	0.7%
8	6765	0.6%
9	5650	0.5%
Other values (3588)	78851	6.8%

Value	Count	Frequency (%)
0	816638	69.9%
1	126656	10.8%
2	49219	4.2%
3	28741	2.5%
4	20841	1.8%
5	14940	1.3%
6	11098	1.0%
7	8548	0.7%
8	6765	0.6%
9	5650	0.5%

Value	Count	Frequency (%)
34495	1	< 0.1%
32571	1	< 0.1%
30619	1	< 0.1%
29815	1	< 0.1%
29166	1	< 0.1%
28894	1	< 0.1%
27713	1	< 0.1%
27238	1	< 0.1%
26638	1	< 0.1%
25893	1	< 0.1%

status
Categorical

Imbalance

The status of the movie (e.g., Released, Rumored, Post Production, etc.)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

Released	1139804
In Production	11398
Post Production	8769
Planned	7280
Rumored	389

Length

Max length	15
Median length	8
Mean length	8.0947851
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Released
2nd row	Released
3rd row	Released
4th row	Released
5th row	Released

Common Values

Value	Count	Frequency (%)
Released	1139804	97.6%
In Production	11398	1.0%
Post Production	8769	0.8%
Planned	7280	0.6%
Rumored	389	< 0.1%
Canceled	307	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
released	1139804	96.9%
production	20167	1.7%
post	8769	0.7%
planned	7280	0.6%
rumored	389	< 0.1%
canceled	307	< 0.1%

release_date
Date

Missing

Date when the movie was released

Distinct	42850
Distinct (%)	4.4%
Missing	200396
Missing (%)	17.2%
Memory size	8.9 MiB

Minimum	1800-01-01 00:00:00
Maximum	2099-11-18 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

revenue
Real number (ℝ)

Skewed Zeros

Total revenue generated by the movie

Distinct	14348
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	686886.16

Minimum	-12
Maximum	5 × 10⁹
Zeros	1146743
Zeros (%)	98.2%
Negative	1
Negative (%)	< 0.1%
Memory size	8.9 MiB

Quantile statistics

Minimum	-12
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5 × 10⁹
Range	5 × 10⁹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18501768
Coefficient of variation (CV)	26.935712
Kurtosis	9726.1226
Mean	686886.16
Median Absolute Deviation (MAD)	0
Skewness	72.235302
Sum	8.0224663 × 10¹¹
Variance	3.4231541 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1146743	98.2%
1	452	< 0.1%
100	452	< 0.1%
10	255	< 0.1%
1000	229	< 0.1%
10000	172	< 0.1%
100000	167	< 0.1%
500	159	< 0.1%
2	143	< 0.1%
5	136	< 0.1%
Other values (14338)	19039	1.6%

Value	Count	Frequency (%)
-12	1	< 0.1%
0	1146743	98.2%
1	452	< 0.1%
2	143	< 0.1%
3	69	< 0.1%
4	40	< 0.1%
5	136	< 0.1%
6	43	< 0.1%
7	29	< 0.1%
8	26	< 0.1%

Value	Count	Frequency (%)
4999999999	1	< 0.1%
3000000000	2	< 0.1%
2930000000	1	< 0.1%
2923706026	1	< 0.1%
2800000000	1	< 0.1%
2320250281	1	< 0.1%
2264162353	1	< 0.1%
2068223624	1	< 0.1%
2052415039	1	< 0.1%
2000000000	1	< 0.1%

runtime
Real number (ℝ)

Skewed Zeros

Duration of the movie in minutes

Distinct	763
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.294949

Minimum	-28
Maximum	14400
Zeros	327120
Zeros (%)	28.0%
Negative	1
Negative (%)	< 0.1%
Memory size	8.9 MiB

Quantile statistics

Minimum	-28
5-th percentile	0
Q1	0
median	21
Q3	88
95-th percentile	135
Maximum	14400
Range	14428
Interquartile range (IQR)	88

Descriptive statistics

Standard deviation	61.603358
Coefficient of variation (CV)	1.3025357
Kurtosis	6490.105
Mean	47.294949
Median Absolute Deviation (MAD)	21
Skewness	34.441811
Sum	55237994
Variance	3794.9737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	327120	28.0%
90	30459	2.6%
10	18397	1.6%
5	17816	1.5%
3	17353	1.5%
7	16728	1.4%
6	16522	1.4%
4	15731	1.3%
15	14914	1.3%
8	14692	1.3%
Other values (753)	678215	58.1%

Value	Count	Frequency (%)
-28	1	< 0.1%
0	327120	28.0%
1	11088	0.9%
2	11943	1.0%
3	17353	1.5%
4	15731	1.3%
5	17816	1.5%
6	16522	1.4%
7	16728	1.4%
8	14692	1.3%

Value	Count	Frequency (%)
14400	1	< 0.1%
13319	1	< 0.1%
12480	1	< 0.1%
9000	1	< 0.1%
7200	1	< 0.1%
5700	1	< 0.1%
5220	1	< 0.1%
4320	1	< 0.1%
3720	1	< 0.1%
2880	1	< 0.1%

adult
Boolean

Imbalance

Indicates if the movie is suitable only for adult audiences

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

False	1057012
True	110935

Value	Count	Frequency (%)
False	1057012	90.5%
True	110935	9.5%

backdrop_path
URL

Missing

URL of the backdrop image for the movie

Distinct	305212
Distinct (%)	99.2%
Missing	860158
Missing (%)	73.6%
Memory size	8.9 MiB

/3CxwYgqGtJ6UEGfWUT0gMYCIlFP.jpg	157
/pOXuMdKnWO9hK8drDahJVQxILHx.jpg	66
/6r2onqJ2S7XhtnU3HbvNmEv8SXK.jpg	47
/60t9ckELUGyinDQNDULFDq2i7u7.jpg	44
/iWSrR35uVcpsnosxprWIxE3l4f8.jpg	43
Other values (305207)	307432
(Missing)	860158

Value	Count	Frequency (%)
/3CxwYgqGtJ6UEGfWUT0gMYCIlFP.jpg	157	< 0.1%
/pOXuMdKnWO9hK8drDahJVQxILHx.jpg	66	< 0.1%
/6r2onqJ2S7XhtnU3HbvNmEv8SXK.jpg	47	< 0.1%
/60t9ckELUGyinDQNDULFDq2i7u7.jpg	44	< 0.1%
/iWSrR35uVcpsnosxprWIxE3l4f8.jpg	43	< 0.1%
/vG0YKrbBQcDSFZYDE1zIqGhqpmc.jpg	38	< 0.1%
/dEJ9tgpv8Ly9VeH2TW1wAm4gBbY.jpg	31	< 0.1%
/3wkhoahQHZRcl7OaKymA2lGPSVg.jpg	27	< 0.1%
/rUcFNAwnTFiKtijDlDp8Ukgz48j.jpg	25	< 0.1%
/49qOx6QBOa2p7dKS16AIrLgX29e.jpg	24	< 0.1%
Other values (305202)	307287	26.3%
(Missing)	860158	73.6%

Value	Count	Frequency (%)
	307789	26.4%
(Missing)	860158	73.6%

Value	Count	Frequency (%)
	307789	26.4%
(Missing)	860158	73.6%

Value	Count	Frequency (%)
/3CxwYgqGtJ6UEGfWUT0gMYCIlFP.jpg	157	< 0.1%
/pOXuMdKnWO9hK8drDahJVQxILHx.jpg	66	< 0.1%
/6r2onqJ2S7XhtnU3HbvNmEv8SXK.jpg	47	< 0.1%
/60t9ckELUGyinDQNDULFDq2i7u7.jpg	44	< 0.1%
/iWSrR35uVcpsnosxprWIxE3l4f8.jpg	43	< 0.1%
/vG0YKrbBQcDSFZYDE1zIqGhqpmc.jpg	38	< 0.1%
/dEJ9tgpv8Ly9VeH2TW1wAm4gBbY.jpg	31	< 0.1%
/3wkhoahQHZRcl7OaKymA2lGPSVg.jpg	27	< 0.1%
/rUcFNAwnTFiKtijDlDp8Ukgz48j.jpg	25	< 0.1%
/49qOx6QBOa2p7dKS16AIrLgX29e.jpg	24	< 0.1%
Other values (305202)	307287	26.3%
(Missing)	860158	73.6%

Value	Count	Frequency (%)
	307789	26.4%
(Missing)	860158	73.6%

Value	Count	Frequency (%)
	307789	26.4%
(Missing)	860158	73.6%

budget
Real number (ℝ)

Skewed Zeros

Budget allocated for the movie

Distinct	5811
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	264891.05

Minimum	0
Maximum	1 × 10⁹
Zeros	1106990
Zeros (%)	94.8%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	7
Maximum	1 × 10⁹
Range	1 × 10⁹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5085605.1
Coefficient of variation (CV)	19.198856
Kurtosis	5433.7432
Mean	264891.05
Median Absolute Deviation (MAD)	0
Skewness	52.508591
Sum	3.0937871 × 10¹¹
Variance	2.5863379 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1106990	94.8%
100	2106	0.2%
1000	1931	0.2%
500	1636	0.1%
10000	1607	0.1%
5000	1582	0.1%
2000	1264	0.1%
200	1115	0.1%
50	1075	0.1%
10	1074	0.1%
Other values (5801)	47567	4.1%

Value	Count	Frequency (%)
0	1106990	94.8%
1	950	0.1%
2	393	< 0.1%
3	256	< 0.1%
4	157	< 0.1%
5	624	0.1%
6	125	< 0.1%
7	111	< 0.1%
8	106	< 0.1%
9	56	< 0.1%

Value	Count	Frequency (%)
999999999	1	< 0.1%
900000000	1	< 0.1%
888000000	1	< 0.1%
800000000	1	< 0.1%
645654654	1	< 0.1%
600000000	2	< 0.1%
540000000	1	< 0.1%
500000000	3	< 0.1%
470000000	1	< 0.1%
460000000	1	< 0.1%

homepage
URL

Missing

Official homepage URL of the movie

Distinct	115402
Distinct (%)	93.8%
Missing	1044970
Missing (%)	89.5%
Memory size	8.9 MiB

https://animation.geidai.ac.jp	147
http://www.eldoradofilms.com	74
https://www.yamidouga.com/	63
https://uaebabes.com	57
http://www.ufc.com	52
Other values (115397)	122584
(Missing)	1044970

Value	Count	Frequency (%)
https://animation.geidai.ac.jp	147	< 0.1%
http://www.eldoradofilms.com	74	< 0.1%
https://www.yamidouga.com/	63	< 0.1%
https://uaebabes.com	57	< 0.1%
http://www.ufc.com	52	< 0.1%
https://www.youtube.com/	52	< 0.1%
https://pinoyflix.to/	50	< 0.1%
http://www.battlefieldhistory.tv	49	< 0.1%
http://www.demand-progress.com	44	< 0.1%
https://parallaximag.gr/to-5o-panorama-tainion-tou-tmimatos-kinimatografou-tou-apth-erchetai-sto-cinobo-114082	40	< 0.1%
Other values (115392)	122349	10.5%
(Missing)	1044970	89.5%

Value	Count	Frequency (%)
https	75483	6.5%
http	47475	4.1%
	19	< 0.1%
(Missing)	1044970	89.5%

Value	Count	Frequency (%)
www.youtube.com	9312	0.8%
vimeo.com	3576	0.3%
www.bbc.co.uk	2032	0.2%
www.netflix.com	1598	0.1%
www.nikkatsu.com	1555	0.1%
youtu.be	1176	0.1%
filmfreeway.com	1075	0.1%
www.facebook.com	1003	0.1%
www.nfb.ca	790	0.1%
www.pbs.org	674	0.1%
Other values (55090)	100186	8.6%
(Missing)	1044970	89.5%

Value	Count	Frequency (%)
/	25250	2.2%
	13861	1.2%
/watch	7819	0.7%
/index.php	275	< 0.1%
/film/info/	239	< 0.1%
/video	182	< 0.1%
/index.html	156	< 0.1%
/en/	155	< 0.1%
/films	131	< 0.1%
/FAMS_ipac/cclib/search/showBib.jsp	118	< 0.1%
Other values (69224)	74791	6.4%
(Missing)	1044970	89.5%

Value	Count	Frequency (%)
	110002	9.4%
lang=en	125	< 0.1%
share=copy	93	< 0.1%
v=7516fd43adaa	59	< 0.1%
showCards=1	45	< 0.1%
fref=ts	26	< 0.1%
locale=en	23	< 0.1%
ref_=ext_shr_lnk	21	< 0.1%
partner_id=24903038	19	< 0.1%
fbclid=IwAR1jSDQd2twJPGTd2bedseZKv17nM7KypVCRgPBxPCc8vpx__L_QzyLrxFA	17	< 0.1%
Other values (12061)	12547	1.1%
(Missing)	1044970	89.5%

Value	Count	Frequency (%)
	121688	10.4%
/	130	< 0.1%
/extra	31	< 0.1%
story	27	< 0.1%
1	18	< 0.1%
overview	12	< 0.1%
home	11	< 0.1%
Review	10	< 0.1%
/fight	10	< 0.1%
WSU	9	< 0.1%
Other values (927)	1031	0.1%
(Missing)	1044970	89.5%

imdb_id
Categorical

High cardinality Missing Uniform

IMDb ID of the movie

Distinct	608703
Distinct (%)	99.8%
Missing	557882
Missing (%)	47.8%
Memory size	8.9 MiB

tt32094375	68
tt13904644	28
tt26900526	20
tt8657468	16
tt23810972	15
Other values (608698)	609918

Length

Max length	10
Median length	9
Mean length	9.1961447
Min length	8

Unique

Unique	607839 ?
Unique (%)	99.6%

Sample

1st row	tt1375666
2nd row	tt0816692
3rd row	tt0468569
4th row	tt0499549
5th row	tt0848228

Common Values

Value	Count	Frequency (%)
tt32094375	68	< 0.1%
tt13904644	28	< 0.1%
tt26900526	20	< 0.1%
tt8657468	16	< 0.1%
tt23810972	15	< 0.1%
tt5719786	13	< 0.1%
tt27430909	12	< 0.1%
tt29703523	11	< 0.1%
tt27048168	10	< 0.1%
tt10980608	10	< 0.1%
Other values (608693)	609862	52.2%
(Missing)	557882	47.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tt32094375	68	< 0.1%
tt13904644	28	< 0.1%
tt26900526	20	< 0.1%
tt8657468	16	< 0.1%
tt23810972	15	< 0.1%
tt5719786	13	< 0.1%
tt27430909	12	< 0.1%
tt29703523	11	< 0.1%
tt27048168	10	< 0.1%
tt10980608	10	< 0.1%
Other values (608693)	609862	> 99.9%

original_language
Categorical

High cardinality Imbalance

Original language in which the movie was produced

Distinct	174
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 MiB

en	631173
fr	68368
es	59270
de	55131
ja	50732
Other values (169)	303273

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	631173	54.0%
fr	68368	5.9%
es	59270	5.1%
de	55131	4.7%
ja	50732	4.3%
zh	39950	3.4%
pt	34610	3.0%
it	24499	2.1%
ru	23989	2.1%
ko	13624	1.2%
Other values (164)	166601	14.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fr	68368	25.6%
zh	39950	15.0%
pt	34610	13.0%
ru	23989	9.0%
cs	11045	4.1%
nl	9222	3.5%
sv	8767	3.3%
tr	8018	3.0%
pl	7293	2.7%
tl	6637	2.5%
Other values (96)	49141	18.4%

original_title
Text

Original title of the movie

Distinct	1034909
Distinct (%)	88.6%
Missing	13
Missing (%)	< 0.1%
Memory size	8.9 MiB

Length

Max length	250
Median length	211
Mean length	18.858123
Min length	1

Unique

Unique	975725 ?
Unique (%)	83.5%

Sample

1st row	Inception
2nd row	Interstellar
3rd row	The Dark Knight
4th row	Avatar
5th row	The Avengers

Value	Count	Frequency (%)
	67711	2.5%
2	18363	0.7%
live	13753	0.5%
3	9393	0.3%
love	9005	0.3%
story	6269	0.2%
4	5894	0.2%
1	5735	0.2%
night	5679	0.2%
life	5572	0.2%
Other values (528342)	2569928	94.6%

overview
Text

Missing

Brief description or summary of the movie

Distinct	899849
Distinct (%)	97.1%
Missing	241564
Missing (%)	20.7%
Memory size	8.9 MiB

Length

Max length	1000
Median length	804
Mean length	269.07154
Min length	1

Unique

Unique	891635 ?
Unique (%)	96.2%

Sample

1st row	Cobb, a skilled thief who commits corporate espionage by infiltrating the subconscious of his targets is offered a chance to regain his old life as payment for a task considered to be impossible: "inception", the implantation of another person's idea into a target's subconscious.
2nd row	The adventures of a group of explorers who make use of a newly discovered wormhole to surpass the limitations on human space travel and conquer the vast distances involved in an interstellar voyage.
3rd row	Batman raises the stakes in his war on crime. With the help of Lt. Jim Gordon and District Attorney Harvey Dent, Batman sets out to dismantle the remaining criminal organizations that plague the streets. The partnership proves to be effective, but they soon find themselves prey to a reign of chaos unleashed by a rising criminal mastermind known to the terrified citizens of Gotham as the Joker.
4th row	In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization.
5th row	When an unexpected enemy emerges and threatens global safety and security, Nick Fury, director of the international peacekeeping agency known as S.H.I.E.L.D., finds himself in need of a team to pull the world back from the brink of disaster. Spanning the globe, a daring recruitment effort begins!

Value	Count	Frequency (%)
film	154890	0.7%
	125066	0.6%
life	114398	0.5%
young	96598	0.5%
love	80665	0.4%
world	74523	0.3%
story	73221	0.3%
time	69949	0.3%
family	57081	0.3%
years	53201	0.2%
Other values (656206)	20545461	95.8%

popularity
Real number (ℝ)

Skewed Zeros

Popularity score of the movie

Distinct	19888
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2143889

Minimum	0
Maximum	2994.357
Zeros	143909
Zeros (%)	12.3%
Negative	0
Negative (%)	0.0%
Memory size	8.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.6
median	0.6
Q3	0.874
95-th percentile	3.185
Maximum	2994.357
Range	2994.357
Interquartile range (IQR)	0.274

Descriptive statistics

Standard deviation	7.4862089
Coefficient of variation (CV)	6.1645891
Kurtosis	50644.927
Mean	1.2143889
Median Absolute Deviation (MAD)	0
Skewness	175.76117
Sum	1418341.9
Variance	56.043324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6	611899	52.4%
0	143909	12.3%
1.4	31267	2.7%
0.84	9171	0.8%
0.65	4155	0.4%
0.841	3666	0.3%
0.9	2252	0.2%
0.651	1902	0.2%
1.09	1719	0.1%
0.621	1558	0.1%
Other values (19878)	356449	30.5%

Value	Count	Frequency (%)
0	143909	12.3%
0.36	7	< 0.1%
0.363	1	< 0.1%
0.59	2	< 0.1%
0.6	611899	52.4%
0.601	977	0.1%
0.602	830	0.1%
0.603	633	0.1%
0.604	527	< 0.1%
0.605	505	< 0.1%

Value	Count	Frequency (%)
2994.357	1	< 0.1%
2680.593	1	< 0.1%
2020.286	1	< 0.1%
1692.778	1	< 0.1%
1567.273	1	< 0.1%
1547.22	1	< 0.1%
1458.514	1	< 0.1%
1175.267	1	< 0.1%
1111.036	1	< 0.1%
1069.34	1	< 0.1%

poster_path
URL

Missing

URL of the movie poster image

Distinct	788737
Distinct (%)	99.4%
Missing	374563
Missing (%)	32.1%
Memory size	8.9 MiB

/sRs2R6qI9C3Liv3hWrQTdmoSqqp.jpg	54
/wtoKLMm4UvkwvcSwO3XWcs1gJuF.jpg	54
/cWjdh8VTiizYfQp5m6fJi4PDy8w.jpg	48
/je3JbUs3OEoYkS6Vd7iv7w6HUPu.jpg	45
/qpXweJ0Gbl5OmYZqzNWtDJovF8e.jpg	41
Other values (788732)	793142
(Missing)	374563

Value	Count	Frequency (%)
/sRs2R6qI9C3Liv3hWrQTdmoSqqp.jpg	54	< 0.1%
/wtoKLMm4UvkwvcSwO3XWcs1gJuF.jpg	54	< 0.1%
/cWjdh8VTiizYfQp5m6fJi4PDy8w.jpg	48	< 0.1%
/je3JbUs3OEoYkS6Vd7iv7w6HUPu.jpg	45	< 0.1%
/qpXweJ0Gbl5OmYZqzNWtDJovF8e.jpg	41	< 0.1%
/nelvhFPqwYhAw8UFF81sDpFZSlD.jpg	39	< 0.1%
/9nQJc8M6u7J4LISv44Y9dMbhQTg.jpg	37	< 0.1%
/28vbk6H0CeVmT4aJRADatqCFXmR.jpg	36	< 0.1%
/AuLuyBTQs0ecbQXnSHwcKRnn6Qo.jpg	34	< 0.1%
/44XDqrWNPiBkIT1ixdtLX23LKlQ.jpg	33	< 0.1%
Other values (788727)	792963	67.9%
(Missing)	374563	32.1%

Value	Count	Frequency (%)
	793384	67.9%
(Missing)	374563	32.1%

Value	Count	Frequency (%)
	793384	67.9%
(Missing)	374563	32.1%

Value	Count	Frequency (%)
/sRs2R6qI9C3Liv3hWrQTdmoSqqp.jpg	54	< 0.1%
/wtoKLMm4UvkwvcSwO3XWcs1gJuF.jpg	54	< 0.1%
/cWjdh8VTiizYfQp5m6fJi4PDy8w.jpg	48	< 0.1%
/je3JbUs3OEoYkS6Vd7iv7w6HUPu.jpg	45	< 0.1%
/qpXweJ0Gbl5OmYZqzNWtDJovF8e.jpg	41	< 0.1%
/nelvhFPqwYhAw8UFF81sDpFZSlD.jpg	39	< 0.1%
/9nQJc8M6u7J4LISv44Y9dMbhQTg.jpg	37	< 0.1%
/28vbk6H0CeVmT4aJRADatqCFXmR.jpg	36	< 0.1%
/AuLuyBTQs0ecbQXnSHwcKRnn6Qo.jpg	34	< 0.1%
/44XDqrWNPiBkIT1ixdtLX23LKlQ.jpg	33	< 0.1%
Other values (788727)	792963	67.9%
(Missing)	374563	32.1%

Value	Count	Frequency (%)
	793384	67.9%
(Missing)	374563	32.1%

Value	Count	Frequency (%)
	793384	67.9%
(Missing)	374563	32.1%

tagline
Text

Missing

Catchphrase or memorable line associated with the movie

Distinct	157115
Distinct (%)	96.0%
Missing	1004366
Missing (%)	86.0%
Memory size	8.9 MiB

Length

Max length	256
Median length	231
Mean length	45.01491
Min length	1

Unique

Unique	154222 ?
Unique (%)	94.3%

Sample

1st row	Your mind is the scene of the crime.
2nd row	Mankind was born on Earth. It was never meant to die here.
3rd row	Welcome to a world without rules.
4th row	Enter the world of Pandora.
5th row	Some assembly required.

Value	Count	Frequency (%)
	8039	1.3%
love	7917	1.2%
story	5762	0.9%
life	5121	0.8%
world	3692	0.6%
film	3481	0.5%
time	3445	0.5%
live	2167	0.3%
back	2064	0.3%
family	1828	0.3%
Other values (67348)	591749	93.1%

genres
Categorical

High cardinality Imbalance Missing

List of genres the movie belongs to

Distinct	13507
Distinct (%)	1.9%
Missing	473732
Missing (%)	40.6%
Memory size	8.9 MiB

Documentary	137983
Drama	108864
Comedy	59900
Animation	32120
Music	25824
Other values (13502)	329524

Length

Max length	173
Median length	144
Mean length	11.936881
Min length	3

Unique

Unique	7904 ?
Unique (%)	1.1%

Sample

1st row	Action, Science Fiction, Adventure
2nd row	Adventure, Drama, Science Fiction
3rd row	Drama, Action, Crime, Thriller
4th row	Action, Adventure, Fantasy, Science Fiction
5th row	Science Fiction, Action, Adventure

Common Values

Value	Count	Frequency (%)
Documentary	137983	11.8%
Drama	108864	9.3%
Comedy	59900	5.1%
Animation	32120	2.8%
Music	25824	2.2%
Horror	22960	2.0%
Drama, Romance	10748	0.9%
Comedy, Drama	9646	0.8%
Action	7973	0.7%
Romance	7870	0.7%
Other values (13497)	270327	23.1%
(Missing)	473732	40.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
drama	229615	21.0%
documentary	168091	15.4%
comedy	141278	12.9%
animation	58449	5.3%
horror	54585	5.0%
romance	53614	4.9%
music	49645	4.5%
thriller	47345	4.3%
action	44854	4.1%
crime	33912	3.1%
Other values (10)	212522	19.4%

production_companies
Categorical

High cardinality Missing

List of production companies involved in the movie

Distinct	209322
Distinct (%)	39.9%
Missing	643803
Missing (%)	55.1%
Memory size	8.9 MiB

Evil Angel	2952
ONF \| NFB	2256
BBC	2151
Metro-Goldwyn-Mayer	2044
Columbia Pictures	1937
Other values (209317)	512804

Length

Max length	708
Median length	423
Mean length	24.523829
Min length	1

Unique

Unique	167678 ?
Unique (%)	32.0%

Sample

1st row	Legendary Pictures, Syncopy, Warner Bros. Pictures
2nd row	Legendary Pictures, Syncopy, Lynda Obst Productions
3rd row	DC Comics, Legendary Pictures, Syncopy, Isobel Griffiths, Warner Bros. Pictures
4th row	Dune Entertainment, Lightstorm Entertainment, 20th Century Fox, Ingenious Media
5th row	Marvel Studios

Common Values

Value	Count	Frequency (%)
Evil Angel	2952	0.3%
ONF \| NFB	2256	0.2%
BBC	2151	0.2%
Metro-Goldwyn-Mayer	2044	0.2%
Columbia Pictures	1937	0.2%
Toei Company	1788	0.2%
Nikkatsu Corporation	1634	0.1%
Universal Pictures	1548	0.1%
Paramount	1510	0.1%
Warner Bros. Pictures	1501	0.1%
Other values (209312)	504823	43.2%
(Missing)	643803	55.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
productions	75932	4.7%
films	75859	4.7%
film	64040	4.0%
pictures	47151	2.9%
entertainment	34449	2.1%
studios	19330	1.2%
media	15514	1.0%
company	15459	1.0%
production	13762	0.9%
studio	13499	0.8%
Other values (101233)	1239339	76.8%

production_countries
Categorical

High cardinality Imbalance Missing

List of countries involved in the movie production

Distinct	10166
Distinct (%)	1.6%
Missing	523518
Missing (%)	44.8%
Memory size	8.9 MiB

United States of America	181180
Japan	41360
United Kingdom	34420
Germany	33265
France	33224
Other values (10161)	320980

Length

Max length	3023
Median length	333
Mean length	13.562084
Min length	4

Unique

Unique	7016 ?
Unique (%)	1.1%

Sample

1st row	United Kingdom, United States of America
2nd row	United Kingdom, United States of America
3rd row	United Kingdom, United States of America
4th row	United States of America, United Kingdom
5th row	United States of America

Common Values

Value	Count	Frequency (%)
United States of America	181180	15.5%
Japan	41360	3.5%
United Kingdom	34420	2.9%
Germany	33265	2.8%
France	33224	2.8%
India	20556	1.8%
Canada	19500	1.7%
Brazil	16411	1.4%
Italy	13581	1.2%
Spain	11742	1.0%
Other values (10156)	239190	20.5%
(Missing)	523518	44.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
united	238371	20.1%
states	196086	16.5%
america	196076	16.5%
france	45379	3.8%
germany	43885	3.7%
japan	43073	3.6%
kingdom	41933	3.5%
canada	24702	2.1%
india	21444	1.8%
italy	19061	1.6%
Other values (282)	315022	26.6%

spoken_languages
Categorical

High cardinality Imbalance Missing

List of languages spoken in the movie

Distinct	7106
Distinct (%)	1.1%
Missing	503846
Missing (%)	43.1%
Memory size	8.9 MiB

English	237622
Japanese	40656
Spanish	37712
French	37091
No Language	29536
Other values (7101)	281484

Length

Max length	177
Median length	7
Mean length	8.1805057
Min length	3

Unique

Unique	4731 ?
Unique (%)	0.7%

Sample

1st row	English, French, Japanese, Swahili
2nd row	English
3rd row	English, Mandarin
4th row	English, Spanish
5th row	English, Hindi, Russian

Common Values

Value	Count	Frequency (%)
English	237622	20.3%
Japanese	40656	3.5%
Spanish	37712	3.2%
French	37091	3.2%
No Language	29536	2.5%
German	28712	2.5%
Portuguese	19068	1.6%
Russian	17022	1.5%
Mandarin	16040	1.4%
Italian	15209	1.3%
Other values (7096)	185433	15.9%
(Missing)	503846	43.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
english	276206	37.4%
french	50186	6.8%
spanish	46898	6.3%
japanese	44157	6.0%
german	38466	5.2%
language	30286	4.1%
portuguese	21711	2.9%
russian	21643	2.9%
italian	20448	2.8%
mandarin	19513	2.6%
Other values (179)	169363	22.9%

keywords
Text

Missing

Keywords associated with the movie

Distinct	179343
Distinct (%)	57.4%
Missing	855292
Missing (%)	73.2%
Memory size	8.9 MiB

Length

Max length	1588
Median length	738
Mean length	37.550393
Min length	1

Unique

Unique	165788 ?
Unique (%)	53.0%

Sample

1st row	rescue, mission, dream, airplane, paris, france, virtual reality, kidnapping, philosophy, spy, allegory, manipulation, car crash, heist, memory, architecture, los angeles, california, dream world, subconscious
2nd row	rescue, future, spacecraft, race against time, artificial intelligence (a.i.), nasa, time warp, dystopia, expedition, space travel, wormhole, famine, black hole, quantum mechanics, family relationships, space, robot, astronaut, scientist, single father, farmer, space station, curious, space adventure, time paradox, thoughtful, time-manipulation, father daughter relationship, 2060s, cornfield, time manipulation, complicated
3rd row	joker, sadism, chaos, secret identity, crime fighter, superhero, anti hero, scarecrow, based on comic, vigilante, organized crime, tragic hero, anti villain, criminal mastermind, district attorney, super power, super villain, neo-noir
4th row	future, society, culture clash, space travel, space war, space colony, tribe, romance, alien, futuristic, space, alien planet, marine, soldier, battle, love affair, nature, anti war, power relations, joyful
5th row	new york city, superhero, shield, based on comic, alien invasion, superhero team, aftercreditsstinger, duringcreditsstinger, marvel cinematic universe (mcu)

Value	Count	Frequency (%)
film	43281	3.0%
short	29485	2.0%
woman	20550	1.4%
gay	18409	1.3%
director	16304	1.1%
sex	15770	1.1%
based	15483	1.1%
pornography	11921	0.8%
relationship	10728	0.7%
comedy	9087	0.6%
Other values (36997)	1257414	86.8%

Interactions

Missing values

A simple visualization of nullity by column.

Sample

	id	title	vote_average	vote_count	status	release_date	revenue	runtime	adult	backdrop_path	budget	homepage	imdb_id	original_language	original_title	overview	popularity	poster_path	tagline	genres	production_companies	production_countries	spoken_languages	keywords
0	27205	Inception	8.364	34495	Released	2010-07-15	825532764	148	False	/8ZTVqvKDQ8emSGUEMjsS4yHAwrp.jpg	160000000	https://www.warnerbros.com/movies/inception	tt1375666	en	Inception	Cobb, a skilled thief who commits corporate espionage by infiltrating the subconscious of his targets is offered a chance to regain his old life as payment for a task considered to be impossible: "inception", the implantation of another person's idea into a target's subconscious.	83.952	/oYuLEt3zVCKq57qu2F8dT7NIa6f.jpg	Your mind is the scene of the crime.	Action, Science Fiction, Adventure	Legendary Pictures, Syncopy, Warner Bros. Pictures	United Kingdom, United States of America	English, French, Japanese, Swahili	rescue, mission, dream, airplane, paris, france, virtual reality, kidnapping, philosophy, spy, allegory, manipulation, car crash, heist, memory, architecture, los angeles, california, dream world, subconscious
1	157336	Interstellar	8.417	32571	Released	2014-11-05	701729206	169	False	/pbrkL804c8yAv3zBZR4QPEafpAR.jpg	165000000	http://www.interstellarmovie.net/	tt0816692	en	Interstellar	The adventures of a group of explorers who make use of a newly discovered wormhole to surpass the limitations on human space travel and conquer the vast distances involved in an interstellar voyage.	140.241	/gEU2QniE6E77NI6lCU6MxlNBvIx.jpg	Mankind was born on Earth. It was never meant to die here.	Adventure, Drama, Science Fiction	Legendary Pictures, Syncopy, Lynda Obst Productions	United Kingdom, United States of America	English	rescue, future, spacecraft, race against time, artificial intelligence (a.i.), nasa, time warp, dystopia, expedition, space travel, wormhole, famine, black hole, quantum mechanics, family relationships, space, robot, astronaut, scientist, single father, farmer, space station, curious, space adventure, time paradox, thoughtful, time-manipulation, father daughter relationship, 2060s, cornfield, time manipulation, complicated
2	155	The Dark Knight	8.512	30619	Released	2008-07-16	1004558444	152	False	/nMKdUUepR0i5zn0y1T4CsSB5chy.jpg	185000000	https://www.warnerbros.com/movies/dark-knight/	tt0468569	en	The Dark Knight	Batman raises the stakes in his war on crime. With the help of Lt. Jim Gordon and District Attorney Harvey Dent, Batman sets out to dismantle the remaining criminal organizations that plague the streets. The partnership proves to be effective, but they soon find themselves prey to a reign of chaos unleashed by a rising criminal mastermind known to the terrified citizens of Gotham as the Joker.	130.643	/qJ2tW6WMUDux911r6m7haRef0WH.jpg	Welcome to a world without rules.	Drama, Action, Crime, Thriller	DC Comics, Legendary Pictures, Syncopy, Isobel Griffiths, Warner Bros. Pictures	United Kingdom, United States of America	English, Mandarin	joker, sadism, chaos, secret identity, crime fighter, superhero, anti hero, scarecrow, based on comic, vigilante, organized crime, tragic hero, anti villain, criminal mastermind, district attorney, super power, super villain, neo-noir
3	19995	Avatar	7.573	29815	Released	2009-12-15	2923706026	162	False	/vL5LR6WdxWPjLPFRLe133jXWsh5.jpg	237000000	https://www.avatar.com/movies/avatar	tt0499549	en	Avatar	In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization.	79.932	/kyeqWdyUXW608qlYkRqosgbbJyK.jpg	Enter the world of Pandora.	Action, Adventure, Fantasy, Science Fiction	Dune Entertainment, Lightstorm Entertainment, 20th Century Fox, Ingenious Media	United States of America, United Kingdom	English, Spanish	future, society, culture clash, space travel, space war, space colony, tribe, romance, alien, futuristic, space, alien planet, marine, soldier, battle, love affair, nature, anti war, power relations, joyful
4	24428	The Avengers	7.710	29166	Released	2012-04-25	1518815515	143	False	/9BBTo63ANSmhC4e6r62OJFuK2GL.jpg	220000000	https://www.marvel.com/movies/the-avengers	tt0848228	en	The Avengers	When an unexpected enemy emerges and threatens global safety and security, Nick Fury, director of the international peacekeeping agency known as S.H.I.E.L.D., finds himself in need of a team to pull the world back from the brink of disaster. Spanning the globe, a daring recruitment effort begins!	98.082	/RYMX2wcKCBAr24UyPD7xwmjaTn.jpg	Some assembly required.	Science Fiction, Action, Adventure	Marvel Studios	United States of America	English, Hindi, Russian	new york city, superhero, shield, based on comic, alien invasion, superhero team, aftercreditsstinger, duringcreditsstinger, marvel cinematic universe (mcu)
5	293660	Deadpool	7.606	28894	Released	2016-02-09	783100000	108	False	/en971MEXui9diirXlogOrPKmsEn.jpg	58000000	https://www.20thcenturystudios.com/movies/deadpool	tt1431045	en	Deadpool	The origin story of former Special Forces operative turned mercenary Wade Wilson, who, after being subjected to a rogue experiment that leaves him with accelerated healing powers, adopts the alter ego Deadpool. Armed with his new abilities and a dark, twisted sense of humor, Deadpool hunts down the man who nearly destroyed his life.	72.735	/zq8Cl3PNIDGU3iWNRoc5nEZ6pCe.jpg	Witness the beginning of a happy ending.	Action, Adventure, Comedy	20th Century Fox, The Donners' Company, Genre Films	United States of America	English	superhero, anti hero, mercenary, based on comic, aftercreditsstinger, duringcreditsstinger
6	299536	Avengers: Infinity War	8.255	27713	Released	2018-04-25	2052415039	149	False	/mDfJG3LC3Dqb67AZ52x3Z0jU0uB.jpg	300000000	https://www.marvel.com/movies/avengers-infinity-war	tt4154756	en	Avengers: Infinity War	As the Avengers and their allies have continued to protect the world from threats too large for any one hero to handle, a new danger has emerged from the cosmic shadows: Thanos. A despot of intergalactic infamy, his goal is to collect all six Infinity Stones, artifacts of unimaginable power, and use them to inflict his twisted will on all of reality. Everything the Avengers have fought for has led up to this moment - the fate of Earth and existence itself has never been more uncertain.	154.340	/7WsyChQLEftFiDOVTGkv3hFpyyt.jpg	An entire universe. Once and for all.	Adventure, Action, Science Fiction	Marvel Studios	United States of America	English, Xhosa	sacrifice, magic, superhero, based on comic, space, battlefield, genocide, magical object, super power, aftercreditsstinger, marvel cinematic universe (mcu), cosmic
7	550	Fight Club	8.438	27238	Released	1999-10-15	100853753	139	False	/hZkgoQYus5vegHoetLkCJzb17zJ.jpg	63000000	http://www.foxmovies.com/movies/fight-club	tt0137523	en	Fight Club	A ticking-time-bomb insomniac and a slippery soap salesman channel primal male aggression into a shocking new form of therapy. Their concept catches on, with underground "fight clubs" forming in every town, until an eccentric gets in the way and ignites an out-of-control spiral toward oblivion.	69.498	/pB8BM7pdSp6B6Ih7QZ4DrQ3PmJK.jpg	Mischief. Mayhem. Soap.	Drama	Regency Enterprises, Fox 2000 Pictures, Taurus Film, Atman Entertainment, Knickerbocker Films, The Linson Company, 20th Century Fox	United States of America	English	dual identity, rage and hate, based on novel or book, nihilism, fight, support group, dystopia, insomnia, alter ego, breaking the fourth wall, split personality, quitting a job, dissociative identity disorder, self destructiveness
8	118340	Guardians of the Galaxy	7.906	26638	Released	2014-07-30	772776600	121	False	/uLtVbjvS1O7gXL8lUOwsFOH4man.jpg	170000000	http://marvel.com/guardians	tt2015381	en	Guardians of the Galaxy	Light years from Earth, 26 years after being abducted, Peter Quill finds himself the prime target of a manhunt after discovering an orb wanted by Ronan the Accuser.	33.255	/r7vmZjiyZw9rpJMQJdXpjgiCOk9.jpg	All heroes start somewhere.	Action, Science Fiction, Adventure	Marvel Studios	United States of America	English	spacecraft, based on comic, space, orphan, adventurer, aftercreditsstinger, duringcreditsstinger, marvel cinematic universe (mcu)
9	680	Pulp Fiction	8.488	25893	Released	1994-09-10	213900000	154	False	/suaEOtk1N1sgg2MTM7oZd2cfVp3.jpg	8500000	https://www.miramax.com/movie/pulp-fiction/	tt0110912	en	Pulp Fiction	A burger-loving hit man, his philosophical partner, a drug-addled gangster's moll and a washed-up boxer converge in this sprawling, comedic crime caper. Their adventures unfurl in three stories that ingeniously trip back and forth in time.	74.862	/d5iIlFn5s0ImszYzBPb8JPIfbXD.jpg	Just because you are a character doesn't mean you have character.	Thriller, Crime	Miramax, A Band Apart, Jersey Films	United States of America	English, Spanish, French	drug dealer, boxer, massage, stolen money, briefcase, crime boss, redemption, heirloom, dance competition, los angeles, california, theft, nonlinear timeline, multiple storylines, neo-noir, hilarious

	id	title	status	release_date	runtime	adult	backdrop_path	homepage	imdb_id	original_language	original_title	overview	popularity	poster_path	tagline	genres	production_companies	production_countries	spoken_languages	keywords
1167937	792595	Undone	Released	NaN	8	False	NaN	https://collab.sundance.org/catalog/Undone-2020-03-16-143009	NaN	en	Undone	After cutting all their hair off and getting caught gender bending, Amelia must navigate a day at school. Seeking for support they eventually find solace in their friends. Sundance Ignite 2021	0.6	/lhrkJFNkRfdTpviLGPQubw15Jdr.jpg	NaN	NaN	NaN	NaN	NaN	sundance ignite
1167938	792596	Extended Perspective, Taking Steps Back	Released	2021-02-01	2	False	NaN	NaN	NaN	en	Extended Perspective, Taking Steps Back	We move out; More and more enter the frame.	0.6	/qU2cz3vGYG9kBfbsBs6nTHvtg8B.jpg	NaN	NaN	NaN	NaN	NaN	NaN
1167939	792597	1.3.6	Released	2004-12-31	41	False	NaN	NaN	NaN	ko	1.3.6	NaN	0.6	NaN	NaN	NaN	NaN	South Korea	Korean	NaN
1167940	276217	The Cure: Rock Case Studies	Released	2007-01-01	0	False	NaN	NaN	NaN	en	The Cure: Rock Case Studies	Music & Musicals, Rockumentaries, Rock & Pop, Modern & Alternative Rock - Featuring performance footage and commentary from musicians, fans and critics, this in-depth analysis of alternative rock band the Cure examines the influence of the unique group that came of age in the post-punk era and continues to draw fans today. A rare archival interview with lead singer Robert Smith sheds light on the Cure's music and history, and footage of the band's performance on British show "The Tube" provides a special treat.	0.6	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1167941	792600	La intemperie sin fin	Released	1977-10-09	44	False	NaN	NaN	NaN	es	La intemperie sin fin	The film “Documentary Experience N ° 3 - Juan L. Ortiz” (Endless Weathering) constitutes an investigative work on one of the greatest Argentine poets.	0.6	/AaH4zwdoMsaT98dVmjYxrLZdXdj.jpg	NaN	Documentary	NaN	Argentina	NaN	NaN
1167942	792601	Cidade de Bebedouro - Est. de São Paulo	Released	1911-01-01	0	False	NaN	NaN	NaN	pt	Cidade de Bebedouro - Est. de São Paulo	NaN	0.6	NaN	NaN	NaN	NaN	Brazil	NaN	NaN
1167943	792602	Los Boys	Released	2012-07-08	82	False	NaN	NaN	NaN	es	Los Boys	If breakdance was a dance of cultural resistance of the Afro community in the US, perhaps this documentary shows a continuity with the northern Argentine adolescence. The Boys Street is a breakdancing group recognized through their presentations on the reality television show Talento Argentino, where they reached the final. Its members are adolescents between 12 and 18 years old from Palpalá, a town in the southeast of the province of Jujuy. Without technical knowledge, the group recorded the process of participating in the program with their own video cameras, crudely portraying their experience as a counterpart to the formality and aestheticization of reality. Los Boys recovers the history of the group at the same time that it captures the daily life of its members in the present day of Palpalá, a town that was recognized as "Mother of Industry" since it had several industrial parks, but was systematically dismantled after the coup d'état and during the privatizations of the '90s.	0.6	/oiPjoYA0x7et43MT0e4Zod2NKCd.jpg	NaN	Documentary	NaN	Argentina	NaN	NaN
1167944	792604	But What Was She Wearing?	Released	2018-11-03	110	False	NaN	NaN	tt10073458	en	But What Was She Wearing?	In 1992, Bhanwari Devi, an Indian social worker hailing from the Kumhar caste in rural Rajasthan, was gang-raped by upper caste men for having the temerity to intervene and stop the child-marriage of an infant. The subsequent acquittal of the accused in connivance with the state machinery outraged India and galvanized women’s activism that led to the Vishaka Guidelines, and subsequently the Sexual Harassment of Women at Workplace Act in 2013. This documentary juxtaposes the law on paper with the ground realities, through a first-of-its-kind log of stories and experiences of over two dozen Indian women; tales of sexual violence that they face - from opulent corporate offices, to construction sites and manual scavenging - and their fight for justice against an obstinate patriarchal state. ‘But What Was She Wearing?’ attempts to portray the impotence of this paper-law and the impossible odds Indian women are up against in pursuit of justice.	0.6	/dmu5rOn1PMOjK5HzkXU8X8Tfuil.jpg	A film on workplace sexual harassment — policies vs reality.	Documentary	Lime Soda Films	India	English, Hindi, Malayalam, Tamil	NaN
1167945	276216	The Chick Corea Elektric Band: Live at the Maintenance Shop	Released	1985-10-30	75	False	/mpBclSCRvjyiPTrBsrisqdmiRon.jpg	NaN	NaN	en	The Chick Corea Elektric Band: Live at the Maintenance Shop	Music & Musicals, Jazz Greats, Classic Jazz, Jazz & Easy Listening - Groundbreaking keyboardist Chick Corea takes the stage at Iowa State University with bassist John Patitucci and drummer Dave Weckl to perform a rousing set of songs of electric jazz fusion, a genre Corea helped define during the 1960s. This 1985 concert showcases the trio's wizardry on tunes such as "King Cockroach," "Malaguena," "Rumble," "India Town" and "Sidewalk." This program also features a biography of the band.	0.6	/mT9le0OFkrTzcPg0orXJT5P3dXT.jpg	NaN	Music	NaN	NaN	English	NaN
1167946	1423447	Thomas & Friends: Daisy and Other Thomas Stories	Released	1993-10-06	36	False	NaN	NaN	NaN	en	Thomas & Friends: Daisy and Other Thomas Stories	PEEP-PEEP! Come Journey to the Island of Sodor and share in the fun-filled escapades of Thomas the Tank Engine and Friends. Meet Daisy, a "classy sassy passenger diesel," as well as Trevor, the very useful tractor engine. You'll see why Percy's up to his funnel in water, Gordon looks foolish, and Henry is proud, in their adventures through the Island of Sodor. So join the gang on Sir Topham Hatt's Railway line in Thomas the Tank Engine and Friends Volume 9.	0.6	/9sTnj6l3aWiDLwyznWC4mBMo87y.jpg	NaN	NaN	NaN	NaN	NaN	NaN

Duplicate rows

Most frequently occurring

	id	title	status	release_date	runtime	adult	backdrop_path	homepage	imdb_id	original_language	original_title	overview	poster_path	tagline	genres	production_companies	production_countries	spoken_languages	keywords	# duplicates
32	1192957	Soldiers From Eastern Europe 13	Released	2005-10-12	114	True	NaN	NaN	NaN	en	Soldiers From Eastern Europe 13	Another combat training session gone suck-cessful! Join Eastern Euro-soldiers as they hit the training facilities for more hardcore sexual man-action!	/3miaWnx10YRplzPW3CDOjC1MGoE.jpg	NaN	NaN	Eagle Video	Czech Republic	NaN	NaN	4
55	1199214	Last Laughs	Released	2023-05-28	47	False	NaN	NaN	NaN	en	Last Laughs	Farewell the Comedy Festival for another year in one glorious night out at SkyCity Theatre! Grab your comedy-loving mates and be a part of the magic as we announce the winners of the prestigious Billy T and Fred Awards, and celebrate the very best of the Fest - all in one show.     Hosted by Chris Parker and featuring headliner Michèle A'Court.	NaN	NaN	NaN	NaN	NaN	English	NaN	4
76	1205264	Hopeless: The Film	Released	2023-09-30	52	True	NaN	NaN	NaN	en	Hopeless: The Film	Hopeless stars Casey Calvert and Lumi Ray as best friends whose relationship metamorphoses into something unexpected - and extraordinary - when a devastated Casey turns to Lumi for comfort after a painful breakup.	NaN	NaN	Romance	Holly Randall Productions	NaN	NaN	lesbian relationship	4
81	1206572	Dude, Don't Fuck My Wife 3	Released	2014-12-15	143	True	NaN	NaN	NaN	en	Dude, Don't Fuck My Wife 3	C'mon man, leave my wife alone! The husbands beg and beg but dudes won't stop fucking their wives. It's a shame. These powerless cuckolds can do nothing but watch as hung lovers and side pieces fuck their wives well right before their very eyes. The wives are unhappy until they get more cock in their pussy. These husbands can't bear to watch but they just can't stop looking.	/336ojave64saSsHKwakJorbH72u.jpg	NaN	NaN	Naughty Sinner	United States of America	NaN	NaN	4
112	1213633	My Sister Is Wet & Horny	Released	2014-10-06	100	True	NaN	NaN	NaN	en	My Sister Is Wet & Horny	A family that lays together stays together! They aren't so little anymore! They've grown up to be so sweet, so wet, so horny and willing to do whatever it takes to keep that big dick in the family! When Isabella De Santos got a look at Ralph's dick pic on twitter she couldn't wait to see how many licks it takes to get every last gooey drop out of his monster cock! Tony came home from college for summer and found Kacey living in his bedroom, they are going to have to share, and guess what? There will be no bunk beds this time! Sandra didn't want Brad to tell everybody from the Old Country about her pussy pies.	/jCxYKTIDfYEQJNZ4xcFxgJmJo80.jpg	NaN	NaN	Lethal Hardcore	NaN	NaN	NaN	4
145	1221745	Last Day	Released	NaN	38	True	NaN	NaN	NaN	en	Last Day	no description yet ...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4
162	1224655	Don't Break Me 39	Released	NaN	155	True	NaN	NaN	NaN	en	Don't Break Me 39	Jackie Hoff gets fucked hard by J-Mac. Hot Latina Maya Farrel graves J-Mac's hard dick. Rachel Starr loves fucking more than anything. Petite Payton Avery takes on J-Mac's thick dick. Catalina Ossa gets her trimmed pussy pounded.	/35FuFb0B1WzaE80gYKcpJen4b5G.jpg	NaN	NaN	NaN	NaN	NaN	NaN	4
163	1224661	Mr. Roberts	Released	NaN	33	False	NaN	NaN	NaN	en	Mr. Roberts	In "Mr. Roberts", written by Terrence McNally and staring Jonathan Taylor Thomas and Steven Weber, a teacher in a 1970's classroom struggles with his closeted gay status and a student who is on the verge of coming out of the closet.	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4
206	1235259	Gogo no Kouchou: Junai Mellow yori	Released	2012-09-21	30	True	NaN	NaN	NaN	ja	午後の紅潮～純愛メロウより～	NaN	NaN	NaN	Animation	NaN	Japan	Japanese	hentai	4
225	1240115	My Pretty Cospet 2	Released	2004-01-01	0	True	NaN	NaN	NaN	es	My Pretty Cospet 2	NaN	/3FkkHtybRMfsOJxzYyc4M3GLPQ3.jpg	NaN	NaN	NaN	Japan	NaN	NaN	4

Overview

Variables

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values

Length

Common Values

Length

Common Values

Length

Common Values

Length

Interactions

Missing values

Sample

Duplicate rows

Most frequently occurring